class SCMBasicInfoMappingConfig:
    """统一管理各sheet的字段映射和字段列表"""
    SHEET_CONFIG = {
        "客户信息": {
            "col_mapping": {
                "客户NO.": "customer_code",
                "备注": "customer_short_name",
                "客户名称": "customer_full_name",
                "姓名": "owner",
                "电话": "phone",
                "公司地址": "address",
                "邮箱": "email",
                "区分": "country",
                "RD现对应者": "business_owner",
                "信用代码": "credit_code",
                "开户行": "bank",
                "银行账号": "bank_account",
                "备注": "customer_remark"
            },
            "fields": [
                "customer_code",
                "customer_short_name",
                "customer_full_name",
                "owner",
                "phone",
                "address",
                "email",
                "country",
                "business_owner",
                "credit_code",
                "bank",
                "bank_account",
                "customer_remark"
            ],
            "required_field": "customer_full_name",
            "navigate_func": "test_navigate_customer_basic_info",
            "add_func": "test_add_customer_basic_info"
            
        },
        "供应商信息": {
            "col_mapping": {
                "供应商NO.": "supplier_basicInfo_code",
                "没有对应列1": "supplier_basicInfo_short_name",
                "供应商名称": "supplier_basicInfo_full_name",
                "信息": "supplier_basicInfo_owner",
                "电话": "supplier_basicInfo_phone",
                "公司地址": "supplier_basicInfo_address",
                "邮箱": "supplier_basicInfo_email",
                "区分": "supplier_basicInfo_domesticOrCrossboard",
                "没有对应列2": "supplier_basicInfo_country",
                "RD现对应者": "supplier_basicInfo_business_owner",
                "没有对应列3": "supplier_basicInfo_credit_code",
                "没有对应列4": "supplier_basicInfo_bank",
                "没有对应列5": "supplier_basicInfo_bank_account",
                "备注": "supplier_basicInfo_remark"
            },
            "fields": [
                "supplier_basicInfo_code",
                "supplier_basicInfo_short_name",
                "supplier_basicInfo_full_name",
                "supplier_basicInfo_owner",
                "supplier_basicInfo_phone",
                "supplier_basicInfo_address",
                "supplier_basicInfo_email",
                "supplier_basicInfo_domesticOrCrossboard",
                "supplier_basicInfo_country",
                "supplier_basicInfo_business_owner",
                "supplier_basicInfo_credit_code",
                "supplier_basicInfo_bank",
                "supplier_basicInfo_bank_account",
                "supplier_basicInfo_remark"
            ],
            "required_field": "supplier_basicInfo_full_name",
            "navigate_func": "test_navigate_supplier_basic_info",
            "add_func": "test_add_supplier_basic_info"
            
        },
        "产品信息": {
            "col_mapping": {
                "图号": "product_basicInfo_code",
                "版本号": "product_basicInfo_version",
                "内部版本号": "product_basicInfo_internal_version",
                "品名": "product_basicInfo_full_name",
                "产品状态": "product_basicInfo_status",
                "颜色": "product_basicInfo_color",
                "材质": "product_basicInfo_material",
                "规格": "product_basicInfo_specification",
                "型号": "product_basicInfo_model",
                "阻燃等级": "product_basicInfo_fireproof_level",
                "图纸构成": "product_basicInfo_drawing_composition",
                "量产单位": "product_basicInfo_production_unit",
                "量产价格": "product_basicInfo_production_price",
                "图纸文件": "product_basicInfo_drawing_file",
                "产品备注": "product_basicInfo_description"
            },
            "fields": [
                "product_basicInfo_code",
                "product_basicInfo_version",
                "product_basicInfo_internal_version",
                "product_basicInfo_full_name",
                "product_basicInfo_status",
                "product_basicInfo_color",
                "product_basicInfo_material",
                "product_basicInfo_specification",
                "product_basicInfo_model",
                "product_basicInfo_fireproof_level",
                "product_basicInfo_drawing_composition",
                "product_basicInfo_production_unit",
                "product_basicInfo_production_price",
                "product_basicInfo_drawing_file",
                "product_basicInfo_description"
            ],
            "required_field": "product_basicInfo_full_name",
            "navigate_func": "test_navigate_product_basic_info",
            "add_func": "test_add_product_basic_info",
           
        }
    }